import sqlite3
import traceback

conn = sqlite3.connect('../database.db')
conn.row_factory = sqlite3.Row

for i in range(288, 806):
    try:
        sql = 'drop table "main"."gate_pass_info_device_{}"'.format(i)
        conn.execute(sql)
        conn.commit()
        print('drop gate_pass_info_device_{}'.format(i))
    except Exception:
        traceback.print_exc()
# sql = 'drop table "main"."gate_pass_info_device_index"'
# conn.execute(sql)
